
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 *
 * @author Irena
 */
public class VerjetnostOsebaPredmet {
    
    private int oseba;
    private int predmet;
    private Connection conn;
    private PreparedStatement ps;
    private ResultSet rs;

    public VerjetnostOsebaPredmet() {
        conn = Connector.vrniPovezavo();
    }
    

    private void pridobiPodatke(int i, int j) throws SQLException {
        ps = conn.prepareStatement("SELECT * FROM is.user_key_word where UserId = ?");
        ps.setInt(1, i);
        rs = ps.executeQuery();
        rs.first();
        String klBesU = rs.getString(2);
        
        
        ps = conn.prepareStatement("SELECT * FROM is.item where ItemId = ?");
        ps.setInt(1, j);
        rs = ps.executeQuery();
        rs.first();
        int kategorija = rs.getInt(2);
        String klBesI = rs.getString(3);
        
    }

   
}
